2007-06-18
Dwarf Fortress Map Archive
Analysis of merging Comments and Points of Interest tables.

dfma_comments
   commentid  int(10)          
   author  varchar(64)              
   comment  text           
   mapid  int(10)            
   dateSubmitted  datetime            
   disabled  bool

dfma_pointsofinterest
   poiid  int(10)      
   mapid  int(10)
   x  int(11)
   y  int(11)
   zoom  decimal(3,2)
   title  varchar(64)          
   description  text         
   submitter  varchar(64)          
   dateSubmitted  datetime 

Proposed Merged Table:
dfma_mapcomments
   commentid  int(10)
   author  varchar(64)
   comment  text           
   mapid  int(10)            
   dateSubmitted  datetime            
   disabled  char(1)
   poiid  int(10)      
   mapid  int(10)
   x  int(11)
   y  int(11)
   zoom  decimal(3,2)
   title  varchar(64)   
   poi  bool

Transitions:
dfma_comments -> dfma_mapcomments
   commentid  ->  ???       
   author  ->  author          
   comment  ->  comment     
   mapid  ->  mapid         
   dateSubmitted  -> dateSubmmitted       
   disabled  ->  disabled
   ???  ->  x
   ???  ->  y
   ???  ->  zoom
   ???  ->  title
   false  ->  poi

dfma_pointsofinterest -> dfma_mapcomments
   poiid  ->  commentid      
   submitter  ->  author   
   description  ->  comment      
   dateSubmitted  -> dateSubmitted
   false  ->  disabled
   mapid  ->  mapid
   x  ->  x
   y  ->  y
   zoom  ->  zoom
   title  ->  title        
   true  ->  poi